<?php
session_start();
if(isset($_SESSION['admin_id'])) {
include ("../include/menu.php");
include('../include/dbFunctions.php');

//GET school ID from URL you just clicked
$sponsor_id = $_GET['id']; //No need to use mysql_real_escape_string since PDO is already catered for it using PREPARED statement
$_SESSION['id'] = $sponsor_id; //Make $id become GLOBAL for passing to next page for UPDATE or DELETE
$_SESSION['sponsor_id'] = $sponsor_id;
/* Query school details from database */
$query1 = "SELECT s.sponsor_name, s.sponsor_description
           FROM sponsor s
           WHERE s.sponsor_id = $sponsor_id";
$result1 = executeSelectQuery($query1);

$query3="SELECT v.volunteer_salutation,v.volunteer_firstname, v.volunteer_surname
         FROM sponsor s, volunteer v
         WHERE s.sponsor_id = $sponsor_id
         AND v.sponsor_id=s.sponsor_id";
$result3 = executeSelectQuery($query3);

$sponsor_name = $result1[0]['sponsor_name'];
$sponsor_description = $result1[0]['sponsor_description'];

/* In the same time, query the school contacts from contact table */
$query2 = " SELECT *
            FROM contact_sponsor
            WHERE sponsor_id = $sponsor_id";
$result2 = executeSelectQuery($query2);


?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
        <title>School Details</title>

        <!--Embed CSS Scripts!-->
        <style type="text/css" title="currentStyle">
            @import "../media/css/dataTable.css";
            @import "../media/css/jquery-ui-1.8.13.custom.css";
            @import "../media/css/screen.css";
        </style>

        <!--Embed Javascripts-->
        <script type="text/javascript" src="../media/js/jquery/jquery-1.6.1.min.js"></script>
        <script type="text/javascript" src="../media/js/jquery/jquery-ui-1.8.13.custom.js"></script>
        <script type="text/javascript" src="../media/js/jquery/jquery.dataTables.min.js"></script>
        <script type="text/javascript" src="../media/js/jquery/ajaxReloadDataTable.js"></script>
        <script type="text/javascript" src="../media/js/jquery/jquery.dataTables.editable.js"></script>
        <script type="text/javascript" src="../media/js/jquery/jquery.validate.js"></script>
        <script type="text/javascript" src="../media/js/jquery/jquery.jeditable.js"></script>
<script type="text/javascript" language="javascript" src="sponsorValidation.js"></script>

        <!--Onsite scripts-->
        <script type="text/javascript" charset="utf-8">

            $(document) .ready(function(){
                //Script to manage school events table
                $("#school_events_table").dataTable({"sPaginationType": "full_numbers"});
                $("#school_contac_table").dataTable({"sPaginationType": "full_numbers"});
                $("#programform").validate(options_validate);

            });


        </script>
    </head>
    <body>
        <!-- DON'T TOUCH! Start: page-top-outer -->
        <?php
        top_outer();
        ?>
        <!-- End: page-top-outer -->

        <div class="clear">&nbsp;</div>

        <!--  start nav-outer-repeat................................................................................................. START -->
        <div class="nav-outer-repeat">
            <!--  start nav-outer -->
            <div class="nav-outer">

                <!-- start nav-right -->
                <?php
                nav_right();
                ?>
                <!-- end nav-right -->


                <!--  start nav -->
                <div class="nav">
                    <div class="table">

                        <?php
                        navigation_sponsor();
                        ?>

                        <div class="clear"></div>
                    </div>
                    <div class="clear"></div>
                </div>
                <!--  start nav -->

            </div>
            <div class="clear"></div>
            <!--  start nav-outer -->
        </div>
        <!--  start nav-outer-repeat................................................... END -->

        <div class="clear"></div>

        <!-- start content-outer ........................................................................................................................START -->
        <div id="content-outer">
            <!-- start content -->
            <div id="content">

                <!--  start page-heading --> <!--lyedit-->
                <div id="page-heading">
                    <h1>Edit Sponsor</h1>
                </div>
                <!-- end page-heading -->

                <table border="0" width="100%" cellpadding="0" cellspacing="0" id="content-table">
                    <tr>
                        <th rowspan="3" class="sized"><img src="../media/images/shared/side_shadowleft.jpg" width="20" height="300" alt="" /></th>
                        <th class="topleft"></th>
                        <td id="tbl-border-top">&nbsp;</td>
                        <th class="topright"></th>
                        <th rowspan="3" class="sized"><img src="../media/images/shared/side_shadowright.jpg" width="20" height="300" alt="" /></th>
                    </tr>
                    <tr>
                        <td id="tbl-border-left"></td>
                        <td>
                            <!--  start content-table-inner ...................................................................... START -->
                            <div id="content-table-inner">
                                <h2></h2>
                                <!--  start table-content  -->
                                <div id="table-content">
                                    <div id="details_content">
                                    <!--  Can put table start from here within this div-->
                                    
                                    <form action="sponsorUpdate.php" method="post" id ="programform">
                                        <table border="0" cellpadding="0" cellspacing="0"  id="id-form">
                                            <input type="hidden" name="id" value=<?php echo $sponsor_id;?>></input>
                                            <tr>
                                                <th valign="top">Sponsor name: </th>
                                                <td>
                                                    <input type="text" name="sponsor_name" class="inp-form" value = '<?php echo $sponsor_name ?>'></input>
                                                </td>
                                            </tr>
                                            <tr></tr>
                                            <tr>
                                                <th valign="top">Sponsor description:</th>
                                                <td>
                                                    <textarea name ="sponsor_description" class="form-textarea"> <?php echo $sponsor_description?>
                                                    </textarea>
                                                </td>
                                            </tr>


                                            <tr>
                                                <th>&nbsp;</th>
                                                <td valign="top">
                                                    <input type="button" value="&nbsp" class="form-back" onClick="javascript:history.go(-1)"/>
                                                    <input type="submit" value="&nbsp" class="form-save" />
                                                    <input type="reset" value="&nbsp" class="form-cancel"  />
                                                </td>
                                                <td></td>
                                            </tr>
                                        </table>
                                    </form>

                                    <!--End of #school_details!-->
                                    <br/>
                                       
                                  

                                </div>
                                    <!--  end table-content here -->
                                </div>
                                <div class="clear"></div>
                            </div>
                            <!--  end content-table-inner ............................................END  -->
                        </td>
                        <td id="tbl-border-right"></td>
                    </tr>
                    <tr>
                        <th class="sized bottomleft"></th>
                        <td id="tbl-border-bottom">&nbsp;</td>
                        <th class="sized bottomright"></th>
                    </tr>
                </table>

                <div class="clear">&nbsp;</div>
            </div><!--  end content -->

            <div class="clear">&nbsp;</div>
        </div>
        <!--  end content-outer........................................................END -->
        <?php
        footer();
        ?>

    </body>
</html>

    <?php
}else {
    header("Location: ../include/login.html");
}
?>